package com.example.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.Chengji;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface ChengjiDao extends BaseMapper<Chengji> {

@Select("select * from chengji")
List<Map<String, Object>> daochuexcel();

//youxxianxci

@Select("SELECT distinct(yuanxi) as aa,count(id) as bb FROM chengji group by yuanxi order by id")
List<Map<String, Object>> chengji_tj_yuanxi();

@Select("SELECT distinct(zhuanye) as aa,count(id) as bb FROM chengji group by zhuanye order by id")
List<Map<String, Object>> chengji_tj_zhuanye();
@Select("SELECT distinct(xuenian) as aa,count(id) as bb FROM chengji group by xuenian order by id")
List<Map<String, Object>> chengji_tj_xuenian();

@Select("SELECT distinct(jingsaihuojiangrenshu) as aa,count(id) as bb FROM chengji group by jingsaihuojiangrenshu order by id")
List<Map<String, Object>> chengji_tj_jingsaihuojiangrenshu();

@Select("SELECT distinct(shengjihuojiangrenshu) as aa,count(id) as bb FROM chengji group by shengjihuojiangrenshu order by id")
List<Map<String, Object>> chengji_tj_shengjihuojiangrenshu();

@Select("SELECT distinct(guojiajirenshu) as aa,count(id) as bb FROM chengji group by guojiajirenshu order by id")
List<Map<String, Object>> chengji_tj_guojiajirenshu();

//tonxgji1

}
